123456/PO PHP H5/Timme - Jisse/speler.php
<?php
include('db1.php');
?>
<head>
<link rel="stylesheet" href="style.css">
</head>
<body>
<?php
$spelerid = $_GET['spelerid'];
$query = "select * from spelers where spelerid = $spelerid";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query");
$row = mysqli_fetch_array($result);
echo "<h1>Naam: $row[voornaam] $row[tussenvoegsel] $row[achternaam] </h1>";
echo "<h3> Geboortejaar: $row[Geb_jaar] </h3>";
echo "<div class=knoppen> ";
$query = "select * from consoles where consoleid = $row[consoleid]";
$result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query");
$row = mysqli_fetch_array($result);
echo "<h2><a href='console3.php?consoleid=$row[consoleid]'> $row[naam_con]</a></h2>";
echo "</div> ";
echo "<h2 class=hoofdpagina><a href='index.php'> hoofdpagina</a></h2>";
?>
</body>
</html>
Resultaat
Made by Thijs Aarnoudse